import pandas as pd

url = 'kafei.xlsx'
coffee_df = pd.read_excel(url)
coffee_df.head()

# SELECT address, category, id, tel FROM tips LIMIT 5;
coffee_df[['address', 'category', 'id', 'tel']].tail(3)

# SELECT * FROM coffee_df WHERE tel = '010-85179080';
coffee_df[coffee_df['tel'] == '400-010-0100'].head(5)

# SELECT id, count(*) FROM tips GROUP BY id;
print(coffee_df.groupby('id').size())

# SELECT * FROM coffee_df LIMIT n;
coffee_df[['address', 'tel']].head(3)
